Spreadsheet Simulator for Inventory Management in a Supply Chain
نویسنده
چکیده
The proper management of inventories in a supply chain is a complex problem. Recently, the use of directly related DRP and MRP systems in supply chains have been increasing. The spreadsheet-based simulator described in this paper was developed to integrate DRP and MRP systems for a proposed hypothetical company . A sample problem that considers all related costs was designed to illustrate how the interrelated excel worksheet-based simulator works. The spreadsheet-based simulator can also be used as an experiential learning activity for teaching inventory management, production planning and supply chain concepts.
منابع مشابه
Simulation based optimization of multi-product supply chain under a JIT system
It is scientifically challenging to determine the inventory level all through the supply chain in such a way that the desired objectives such as effectiveness and responsiveness of the supply chain system can be obtained. Simulation is a means for solving various problems which cannot be solved by regular exact models such as mathematical ones due to their complexity. The present paper is aime...
متن کاملMaterial Inventory Optimization in Bakery Supply Chain: Implications for Food Security in Nigeria
The study determined optimum inventory levels for various bakery resources using the bread supply chain network in Onitsha City. Structured questionnaires were administered among bakery factories. The optimum design achieved through the optimization model was compared with the existing systems. Analysis of 90 bakeries with a combined capacity of 3960 revealed that total money N 564,408,477.28 i...
متن کاملAn Inventory Model for Deteriorating Items Using Vendor-Managed Inventory Policy
In recent researches, vendor managed inventory (VMI) policy is rarely considered for deteriorating items. This study considered the supply chain partner’s collaboration via a VMI system and provided an EOQ model for a two-level supply chain (single supplier - single retailer) to examine the inventory management proceedings for VMI and non-VMI supply chains. By a new approach in modeling, the ...
متن کاملThe Bullwhip Effect on the VMI-Supply Chain Management viaSystem Dynamics Approach: The Supply Chain with Two Suppliers and One Retail Channel
This work investigates the effect of different inventory policies of a supply chain model using the system dynamics approach which belongs to the class of Vendor Managed Inventory (VMI), automatic pipeline, inventory and order based production control systems (VMI-APIOBPCS). This work helps management to investigate the effect of different policies such as adding the VMI system or third party l...
متن کاملDetermination of a Desirable Inventory Policy in a three Echelon Multilayer Supply Chain with Normal Demand
Inventory control is one of the most important issues in supply chain management. In this paper, a three-echelon production, distribution, inventory system composed of one producer, a set of wholesalers and retailers is considered. Costumers' demands can be approximated by a normal distribution and the inventory policy is a kind of continuous review (R, Q). In this paper, a model based on stand...
متن کامل